package com.qj.travel.db.dao;

import com.qj.travel.db.model.VideoInfoModel;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created by Admin on 2016/10/1.
 */
public interface VideoInfoDao {
    List<VideoInfoModel> getVideoInfoList();
    List<VideoInfoModel> getVideoBySort(@Param("videoClass") String videoClass,@Param("startRow") int startRow,@Param("pageSize") int pageSize);
    List<VideoInfoModel> getVideoPublished(@Param("startRow") int startRow,@Param("pageSize") int pageSize);
    List<VideoInfoModel> getVideoPublishedBySort(@Param("videoClass") String videoClass,@Param("startRow") int startRow,@Param("pageSize") int pageSize);
    List<VideoInfoModel> getVideoNotPublished(@Param("startRow") int startRow,@Param("pageSize") int pageSize);
    VideoInfoModel getVideoInfo(int videoId);
    int insertVideoInfo(VideoInfoModel videoInfoModel);
    int updateVoteNum(@Param("videoId")int videoId,@Param("voteNum")int voteNum);
    List<VideoInfoModel> getVideoInfoLisyByPage(@Param("startRow") int startRow,@Param("pageSize") int pageSize);
    int updatePublish(int videoId);
    int cancelPublish(int videoId);
    int deleteVideo(int videoId);
    int getVideoStatus(int videoId);
    int updateLock(int videoId);
    int updateNotPass(int videoId);
    int updateVideoInfo(@Param("videoId")int videoId,@Param("videoName")String videoName,@Param("videoIntro")String videoIntro,@Param("videoClass")String videoClass);
    List<VideoInfoModel> getVideoByUser(String userId);
    List<VideoInfoModel> getVideoByUserPublished(String userId);
    List<VideoInfoModel> getVideoByUserNotPublished(String userId);
    int insertMessage(@Param("videoId") int videoId,@Param("message") String message);
    List<VideoInfoModel> getVideoByUserNotPass(String userId);
    List<VideoInfoModel> getVideoNotPass();
}
